package t327.mapper;

import org.apache.ibatis.annotations.Param;
import t327.pojo.*;
import t327.pojo.StoreArea;
import t327.pojo.views.MaterialStoreView;
import t327.pojo.views.SubmitOrderStyleProductMaterialsView;
import t327.pojo.views.WarehouseStoreAreaBatchView;

import java.util.HashMap;
import java.util.List;

public interface WareHouseMapper {
    List<WarehouseStoreAreaBatchView> queryAllWarehouseStoreAreaBatchView();

    List<WarehouseStoreAreaBatchView> queryByName(@Param("mm") String searchValue);

    List<WarehouseStoreAreaBatchView> getAllWarehouseStoreAreaBatchView();
    //查询物料
    List<Materials> queryAllMaterials();

    //查询仓库区域
    List<StoreArea> queryAllStoreArea();
    //查询颜色
    List<Color> queryAllColor();
    //查询仓库
    List<Warehouse> queryAllWarehouse();
    //查询种类
    List<MaterialKind> queryAllMaterialKind();
    //查询规格
    List<Quality> queryAllQuality();
    //添加物料
    int addMaterials(Materials materials);
    //添加物料颜色
    int addColorMaterialsRel(ColorMaterialsRel colorMaterialsRel);
    //添加批次
    int addBatch(Batch batch);
    //添加物料进库
//    int addMaterialStoreRel(MaterialStoreRel materialStoreRel);
    //添加仓库  r
    int addStore(Store store);
    //添加仓库
    int addStoreAreaWarehouseRel(StoreAreaWarehouseRel storeAreaWarehouseRel);

    //    int addMaterials(Materials materials);
//    物料的出库
    int addMaterialStoreRelchu(MaterialStoreRel materialStoreRel);
    int addStorechu(Store store);
    //    物料的入库
    int addMaterialStoreRelRu(MaterialStoreRel materialStoreRel);
    int addStoreRu(Store store);

    List<Materials>getAllMaterials();

    List<SubmitOrderStyleProductMaterialsView>getSubMaterialViewAll();

    int updatelMaterials(Long id);

    int updatOrderAuditStatus(Long orderId);

    int addInventory(Inventory inventory);
    Inventory queryInventory(Long  orderId);

    StoreAreaWarehouseRel queryStoreAreaWarehouseRel(Long storeAreaWarehouseRelId);

    Store queryStore(Long storeId);

    int updateStore(Store store);

}
